package org.dromara.tearoom.mapper;

import org.apache.ibatis.annotations.Select;
import org.dromara.tearoom.domain.TerHornEquipment;
import org.dromara.tearoom.domain.vo.TerHornEquipmentVo;
import org.dromara.common.mybatis.core.mapper.BaseMapperPlus;

import java.util.List;

/**
 * 喇叭设备管理Mapper接口
 *
 * @author xch
 * @date 2025-04-23
 */
public interface TerHornEquipmentMapper extends BaseMapperPlus<TerHornEquipment, TerHornEquipmentVo> {
    @Select(" select th.*, tl.cookie_value, tl.modify_time FROM ter_horn_equipment th left JOIN ter_horn_login tl on  th.id = tl.device_id where th.del_flag ='0' " )
    List<TerHornEquipmentVo> selectEquipmentAndCookie();
}
